package com.woniu.sale.entity;

import java.math.BigDecimal;
import java.util.ArrayList;
import java.util.Date;
import java.util.List;

public class BsProductExample {
    protected String orderByClause;

    protected boolean distinct;

    protected List<Criteria> oredCriteria;

    private Integer limit;

    private Long offset;

    public BsProductExample() {
        oredCriteria = new ArrayList<Criteria>();
    }

    public void setOrderByClause(String orderByClause) {
        this.orderByClause = orderByClause;
    }

    public String getOrderByClause() {
        return orderByClause;
    }

    public void setDistinct(boolean distinct) {
        this.distinct = distinct;
    }

    public boolean isDistinct() {
        return distinct;
    }

    public List<Criteria> getOredCriteria() {
        return oredCriteria;
    }

    public void or(Criteria criteria) {
        oredCriteria.add(criteria);
    }

    public Criteria or() {
        Criteria criteria = createCriteriaInternal();
        oredCriteria.add(criteria);
        return criteria;
    }

    public Criteria createCriteria() {
        Criteria criteria = createCriteriaInternal();
        if (oredCriteria.size() == 0) {
            oredCriteria.add(criteria);
        }
        return criteria;
    }

    protected Criteria createCriteriaInternal() {
        Criteria criteria = new Criteria();
        return criteria;
    }

    public void clear() {
        oredCriteria.clear();
        orderByClause = null;
        distinct = false;
    }

    public void setLimit(Integer limit) {
        this.limit = limit;
    }

    public Integer getLimit() {
        return limit;
    }

    public void setOffset(Long offset) {
        this.offset = offset;
    }

    public Long getOffset() {
        return offset;
    }

    protected abstract static class GeneratedCriteria {
        protected List<Criterion> criteria;

        protected GeneratedCriteria() {
            super();
            criteria = new ArrayList<Criterion>();
        }

        public boolean isValid() {
            return criteria.size() > 0;
        }

        public List<Criterion> getAllCriteria() {
            return criteria;
        }

        public List<Criterion> getCriteria() {
            return criteria;
        }

        protected void addCriterion(String condition) {
            if (condition == null) {
                throw new RuntimeException("Value for condition cannot be null");
            }
            criteria.add(new Criterion(condition));
        }

        protected void addCriterion(String condition, Object value, String property) {
            if (value == null) {
                throw new RuntimeException("Value for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value));
        }

        protected void addCriterion(String condition, Object value1, Object value2, String property) {
            if (value1 == null || value2 == null) {
                throw new RuntimeException("Between values for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value1, value2));
        }

        public Criteria andProdnoIsNull() {
            addCriterion("prodNO is null");
            return (Criteria) this;
        }

        public Criteria andProdnoIsNotNull() {
            addCriterion("prodNO is not null");
            return (Criteria) this;
        }

        public Criteria andProdnoEqualTo(String value) {
            addCriterion("prodNO =", value, "prodno");
            return (Criteria) this;
        }

        public Criteria andProdnoNotEqualTo(String value) {
            addCriterion("prodNO <>", value, "prodno");
            return (Criteria) this;
        }

        public Criteria andProdnoGreaterThan(String value) {
            addCriterion("prodNO >", value, "prodno");
            return (Criteria) this;
        }

        public Criteria andProdnoGreaterThanOrEqualTo(String value) {
            addCriterion("prodNO >=", value, "prodno");
            return (Criteria) this;
        }

        public Criteria andProdnoLessThan(String value) {
            addCriterion("prodNO <", value, "prodno");
            return (Criteria) this;
        }

        public Criteria andProdnoLessThanOrEqualTo(String value) {
            addCriterion("prodNO <=", value, "prodno");
            return (Criteria) this;
        }

        public Criteria andProdnoLike(String value) {
            addCriterion("prodNO like", value, "prodno");
            return (Criteria) this;
        }

        public Criteria andProdnoNotLike(String value) {
            addCriterion("prodNO not like", value, "prodno");
            return (Criteria) this;
        }

        public Criteria andProdnoIn(List<String> values) {
            addCriterion("prodNO in", values, "prodno");
            return (Criteria) this;
        }

        public Criteria andProdnoNotIn(List<String> values) {
            addCriterion("prodNO not in", values, "prodno");
            return (Criteria) this;
        }

        public Criteria andProdnoBetween(String value1, String value2) {
            addCriterion("prodNO between", value1, value2, "prodno");
            return (Criteria) this;
        }

        public Criteria andProdnoNotBetween(String value1, String value2) {
            addCriterion("prodNO not between", value1, value2, "prodno");
            return (Criteria) this;
        }

        public Criteria andProdkndnoIsNull() {
            addCriterion("prodKNDNO is null");
            return (Criteria) this;
        }

        public Criteria andProdkndnoIsNotNull() {
            addCriterion("prodKNDNO is not null");
            return (Criteria) this;
        }

        public Criteria andProdkndnoEqualTo(String value) {
            addCriterion("prodKNDNO =", value, "prodkndno");
            return (Criteria) this;
        }

        public Criteria andProdkndnoNotEqualTo(String value) {
            addCriterion("prodKNDNO <>", value, "prodkndno");
            return (Criteria) this;
        }

        public Criteria andProdkndnoGreaterThan(String value) {
            addCriterion("prodKNDNO >", value, "prodkndno");
            return (Criteria) this;
        }

        public Criteria andProdkndnoGreaterThanOrEqualTo(String value) {
            addCriterion("prodKNDNO >=", value, "prodkndno");
            return (Criteria) this;
        }

        public Criteria andProdkndnoLessThan(String value) {
            addCriterion("prodKNDNO <", value, "prodkndno");
            return (Criteria) this;
        }

        public Criteria andProdkndnoLessThanOrEqualTo(String value) {
            addCriterion("prodKNDNO <=", value, "prodkndno");
            return (Criteria) this;
        }

        public Criteria andProdkndnoLike(String value) {
            addCriterion("prodKNDNO like", value, "prodkndno");
            return (Criteria) this;
        }

        public Criteria andProdkndnoNotLike(String value) {
            addCriterion("prodKNDNO not like", value, "prodkndno");
            return (Criteria) this;
        }

        public Criteria andProdkndnoIn(List<String> values) {
            addCriterion("prodKNDNO in", values, "prodkndno");
            return (Criteria) this;
        }

        public Criteria andProdkndnoNotIn(List<String> values) {
            addCriterion("prodKNDNO not in", values, "prodkndno");
            return (Criteria) this;
        }

        public Criteria andProdkndnoBetween(String value1, String value2) {
            addCriterion("prodKNDNO between", value1, value2, "prodkndno");
            return (Criteria) this;
        }

        public Criteria andProdkndnoNotBetween(String value1, String value2) {
            addCriterion("prodKNDNO not between", value1, value2, "prodkndno");
            return (Criteria) this;
        }

        public Criteria andProdrootnoIsNull() {
            addCriterion("prodRootNO is null");
            return (Criteria) this;
        }

        public Criteria andProdrootnoIsNotNull() {
            addCriterion("prodRootNO is not null");
            return (Criteria) this;
        }

        public Criteria andProdrootnoEqualTo(String value) {
            addCriterion("prodRootNO =", value, "prodrootno");
            return (Criteria) this;
        }

        public Criteria andProdrootnoNotEqualTo(String value) {
            addCriterion("prodRootNO <>", value, "prodrootno");
            return (Criteria) this;
        }

        public Criteria andProdrootnoGreaterThan(String value) {
            addCriterion("prodRootNO >", value, "prodrootno");
            return (Criteria) this;
        }

        public Criteria andProdrootnoGreaterThanOrEqualTo(String value) {
            addCriterion("prodRootNO >=", value, "prodrootno");
            return (Criteria) this;
        }

        public Criteria andProdrootnoLessThan(String value) {
            addCriterion("prodRootNO <", value, "prodrootno");
            return (Criteria) this;
        }

        public Criteria andProdrootnoLessThanOrEqualTo(String value) {
            addCriterion("prodRootNO <=", value, "prodrootno");
            return (Criteria) this;
        }

        public Criteria andProdrootnoLike(String value) {
            addCriterion("prodRootNO like", value, "prodrootno");
            return (Criteria) this;
        }

        public Criteria andProdrootnoNotLike(String value) {
            addCriterion("prodRootNO not like", value, "prodrootno");
            return (Criteria) this;
        }

        public Criteria andProdrootnoIn(List<String> values) {
            addCriterion("prodRootNO in", values, "prodrootno");
            return (Criteria) this;
        }

        public Criteria andProdrootnoNotIn(List<String> values) {
            addCriterion("prodRootNO not in", values, "prodrootno");
            return (Criteria) this;
        }

        public Criteria andProdrootnoBetween(String value1, String value2) {
            addCriterion("prodRootNO between", value1, value2, "prodrootno");
            return (Criteria) this;
        }

        public Criteria andProdrootnoNotBetween(String value1, String value2) {
            addCriterion("prodRootNO not between", value1, value2, "prodrootno");
            return (Criteria) this;
        }

        public Criteria andProvideridIsNull() {
            addCriterion("providerID is null");
            return (Criteria) this;
        }

        public Criteria andProvideridIsNotNull() {
            addCriterion("providerID is not null");
            return (Criteria) this;
        }

        public Criteria andProvideridEqualTo(String value) {
            addCriterion("providerID =", value, "providerid");
            return (Criteria) this;
        }

        public Criteria andProvideridNotEqualTo(String value) {
            addCriterion("providerID <>", value, "providerid");
            return (Criteria) this;
        }

        public Criteria andProvideridGreaterThan(String value) {
            addCriterion("providerID >", value, "providerid");
            return (Criteria) this;
        }

        public Criteria andProvideridGreaterThanOrEqualTo(String value) {
            addCriterion("providerID >=", value, "providerid");
            return (Criteria) this;
        }

        public Criteria andProvideridLessThan(String value) {
            addCriterion("providerID <", value, "providerid");
            return (Criteria) this;
        }

        public Criteria andProvideridLessThanOrEqualTo(String value) {
            addCriterion("providerID <=", value, "providerid");
            return (Criteria) this;
        }

        public Criteria andProvideridLike(String value) {
            addCriterion("providerID like", value, "providerid");
            return (Criteria) this;
        }

        public Criteria andProvideridNotLike(String value) {
            addCriterion("providerID not like", value, "providerid");
            return (Criteria) this;
        }

        public Criteria andProvideridIn(List<String> values) {
            addCriterion("providerID in", values, "providerid");
            return (Criteria) this;
        }

        public Criteria andProvideridNotIn(List<String> values) {
            addCriterion("providerID not in", values, "providerid");
            return (Criteria) this;
        }

        public Criteria andProvideridBetween(String value1, String value2) {
            addCriterion("providerID between", value1, value2, "providerid");
            return (Criteria) this;
        }

        public Criteria andProvideridNotBetween(String value1, String value2) {
            addCriterion("providerID not between", value1, value2, "providerid");
            return (Criteria) this;
        }

        public Criteria andProdclassnoIsNull() {
            addCriterion("prodClassNO is null");
            return (Criteria) this;
        }

        public Criteria andProdclassnoIsNotNull() {
            addCriterion("prodClassNO is not null");
            return (Criteria) this;
        }

        public Criteria andProdclassnoEqualTo(String value) {
            addCriterion("prodClassNO =", value, "prodclassno");
            return (Criteria) this;
        }

        public Criteria andProdclassnoNotEqualTo(String value) {
            addCriterion("prodClassNO <>", value, "prodclassno");
            return (Criteria) this;
        }

        public Criteria andProdclassnoGreaterThan(String value) {
            addCriterion("prodClassNO >", value, "prodclassno");
            return (Criteria) this;
        }

        public Criteria andProdclassnoGreaterThanOrEqualTo(String value) {
            addCriterion("prodClassNO >=", value, "prodclassno");
            return (Criteria) this;
        }

        public Criteria andProdclassnoLessThan(String value) {
            addCriterion("prodClassNO <", value, "prodclassno");
            return (Criteria) this;
        }

        public Criteria andProdclassnoLessThanOrEqualTo(String value) {
            addCriterion("prodClassNO <=", value, "prodclassno");
            return (Criteria) this;
        }

        public Criteria andProdclassnoLike(String value) {
            addCriterion("prodClassNO like", value, "prodclassno");
            return (Criteria) this;
        }

        public Criteria andProdclassnoNotLike(String value) {
            addCriterion("prodClassNO not like", value, "prodclassno");
            return (Criteria) this;
        }

        public Criteria andProdclassnoIn(List<String> values) {
            addCriterion("prodClassNO in", values, "prodclassno");
            return (Criteria) this;
        }

        public Criteria andProdclassnoNotIn(List<String> values) {
            addCriterion("prodClassNO not in", values, "prodclassno");
            return (Criteria) this;
        }

        public Criteria andProdclassnoBetween(String value1, String value2) {
            addCriterion("prodClassNO between", value1, value2, "prodclassno");
            return (Criteria) this;
        }

        public Criteria andProdclassnoNotBetween(String value1, String value2) {
            addCriterion("prodClassNO not between", value1, value2, "prodclassno");
            return (Criteria) this;
        }

        public Criteria andProdcodeIsNull() {
            addCriterion("prodCode is null");
            return (Criteria) this;
        }

        public Criteria andProdcodeIsNotNull() {
            addCriterion("prodCode is not null");
            return (Criteria) this;
        }

        public Criteria andProdcodeEqualTo(String value) {
            addCriterion("prodCode =", value, "prodcode");
            return (Criteria) this;
        }

        public Criteria andProdcodeNotEqualTo(String value) {
            addCriterion("prodCode <>", value, "prodcode");
            return (Criteria) this;
        }

        public Criteria andProdcodeGreaterThan(String value) {
            addCriterion("prodCode >", value, "prodcode");
            return (Criteria) this;
        }

        public Criteria andProdcodeGreaterThanOrEqualTo(String value) {
            addCriterion("prodCode >=", value, "prodcode");
            return (Criteria) this;
        }

        public Criteria andProdcodeLessThan(String value) {
            addCriterion("prodCode <", value, "prodcode");
            return (Criteria) this;
        }

        public Criteria andProdcodeLessThanOrEqualTo(String value) {
            addCriterion("prodCode <=", value, "prodcode");
            return (Criteria) this;
        }

        public Criteria andProdcodeLike(String value) {
            addCriterion("prodCode like", value, "prodcode");
            return (Criteria) this;
        }

        public Criteria andProdcodeNotLike(String value) {
            addCriterion("prodCode not like", value, "prodcode");
            return (Criteria) this;
        }

        public Criteria andProdcodeIn(List<String> values) {
            addCriterion("prodCode in", values, "prodcode");
            return (Criteria) this;
        }

        public Criteria andProdcodeNotIn(List<String> values) {
            addCriterion("prodCode not in", values, "prodcode");
            return (Criteria) this;
        }

        public Criteria andProdcodeBetween(String value1, String value2) {
            addCriterion("prodCode between", value1, value2, "prodcode");
            return (Criteria) this;
        }

        public Criteria andProdcodeNotBetween(String value1, String value2) {
            addCriterion("prodCode not between", value1, value2, "prodcode");
            return (Criteria) this;
        }

        public Criteria andBarcodeIsNull() {
            addCriterion("barcode is null");
            return (Criteria) this;
        }

        public Criteria andBarcodeIsNotNull() {
            addCriterion("barcode is not null");
            return (Criteria) this;
        }

        public Criteria andBarcodeEqualTo(String value) {
            addCriterion("barcode =", value, "barcode");
            return (Criteria) this;
        }

        public Criteria andBarcodeNotEqualTo(String value) {
            addCriterion("barcode <>", value, "barcode");
            return (Criteria) this;
        }

        public Criteria andBarcodeGreaterThan(String value) {
            addCriterion("barcode >", value, "barcode");
            return (Criteria) this;
        }

        public Criteria andBarcodeGreaterThanOrEqualTo(String value) {
            addCriterion("barcode >=", value, "barcode");
            return (Criteria) this;
        }

        public Criteria andBarcodeLessThan(String value) {
            addCriterion("barcode <", value, "barcode");
            return (Criteria) this;
        }

        public Criteria andBarcodeLessThanOrEqualTo(String value) {
            addCriterion("barcode <=", value, "barcode");
            return (Criteria) this;
        }

        public Criteria andBarcodeLike(String value) {
            addCriterion("barcode like", value, "barcode");
            return (Criteria) this;
        }

        public Criteria andBarcodeNotLike(String value) {
            addCriterion("barcode not like", value, "barcode");
            return (Criteria) this;
        }

        public Criteria andBarcodeIn(List<String> values) {
            addCriterion("barcode in", values, "barcode");
            return (Criteria) this;
        }

        public Criteria andBarcodeNotIn(List<String> values) {
            addCriterion("barcode not in", values, "barcode");
            return (Criteria) this;
        }

        public Criteria andBarcodeBetween(String value1, String value2) {
            addCriterion("barcode between", value1, value2, "barcode");
            return (Criteria) this;
        }

        public Criteria andBarcodeNotBetween(String value1, String value2) {
            addCriterion("barcode not between", value1, value2, "barcode");
            return (Criteria) this;
        }

        public Criteria andProdnameIsNull() {
            addCriterion("prodName is null");
            return (Criteria) this;
        }

        public Criteria andProdnameIsNotNull() {
            addCriterion("prodName is not null");
            return (Criteria) this;
        }

        public Criteria andProdnameEqualTo(String value) {
            addCriterion("prodName =", value, "prodname");
            return (Criteria) this;
        }

        public Criteria andProdnameNotEqualTo(String value) {
            addCriterion("prodName <>", value, "prodname");
            return (Criteria) this;
        }

        public Criteria andProdnameGreaterThan(String value) {
            addCriterion("prodName >", value, "prodname");
            return (Criteria) this;
        }

        public Criteria andProdnameGreaterThanOrEqualTo(String value) {
            addCriterion("prodName >=", value, "prodname");
            return (Criteria) this;
        }

        public Criteria andProdnameLessThan(String value) {
            addCriterion("prodName <", value, "prodname");
            return (Criteria) this;
        }

        public Criteria andProdnameLessThanOrEqualTo(String value) {
            addCriterion("prodName <=", value, "prodname");
            return (Criteria) this;
        }

        public Criteria andProdnameLike(String value) {
            addCriterion("prodName like", value, "prodname");
            return (Criteria) this;
        }

        public Criteria andProdnameNotLike(String value) {
            addCriterion("prodName not like", value, "prodname");
            return (Criteria) this;
        }

        public Criteria andProdnameIn(List<String> values) {
            addCriterion("prodName in", values, "prodname");
            return (Criteria) this;
        }

        public Criteria andProdnameNotIn(List<String> values) {
            addCriterion("prodName not in", values, "prodname");
            return (Criteria) this;
        }

        public Criteria andProdnameBetween(String value1, String value2) {
            addCriterion("prodName between", value1, value2, "prodname");
            return (Criteria) this;
        }

        public Criteria andProdnameNotBetween(String value1, String value2) {
            addCriterion("prodName not between", value1, value2, "prodname");
            return (Criteria) this;
        }

        public Criteria andProdshortIsNull() {
            addCriterion("prodShort is null");
            return (Criteria) this;
        }

        public Criteria andProdshortIsNotNull() {
            addCriterion("prodShort is not null");
            return (Criteria) this;
        }

        public Criteria andProdshortEqualTo(String value) {
            addCriterion("prodShort =", value, "prodshort");
            return (Criteria) this;
        }

        public Criteria andProdshortNotEqualTo(String value) {
            addCriterion("prodShort <>", value, "prodshort");
            return (Criteria) this;
        }

        public Criteria andProdshortGreaterThan(String value) {
            addCriterion("prodShort >", value, "prodshort");
            return (Criteria) this;
        }

        public Criteria andProdshortGreaterThanOrEqualTo(String value) {
            addCriterion("prodShort >=", value, "prodshort");
            return (Criteria) this;
        }

        public Criteria andProdshortLessThan(String value) {
            addCriterion("prodShort <", value, "prodshort");
            return (Criteria) this;
        }

        public Criteria andProdshortLessThanOrEqualTo(String value) {
            addCriterion("prodShort <=", value, "prodshort");
            return (Criteria) this;
        }

        public Criteria andProdshortLike(String value) {
            addCriterion("prodShort like", value, "prodshort");
            return (Criteria) this;
        }

        public Criteria andProdshortNotLike(String value) {
            addCriterion("prodShort not like", value, "prodshort");
            return (Criteria) this;
        }

        public Criteria andProdshortIn(List<String> values) {
            addCriterion("prodShort in", values, "prodshort");
            return (Criteria) this;
        }

        public Criteria andProdshortNotIn(List<String> values) {
            addCriterion("prodShort not in", values, "prodshort");
            return (Criteria) this;
        }

        public Criteria andProdshortBetween(String value1, String value2) {
            addCriterion("prodShort between", value1, value2, "prodshort");
            return (Criteria) this;
        }

        public Criteria andProdshortNotBetween(String value1, String value2) {
            addCriterion("prodShort not between", value1, value2, "prodshort");
            return (Criteria) this;
        }

        public Criteria andProdengIsNull() {
            addCriterion("prodEng is null");
            return (Criteria) this;
        }

        public Criteria andProdengIsNotNull() {
            addCriterion("prodEng is not null");
            return (Criteria) this;
        }

        public Criteria andProdengEqualTo(String value) {
            addCriterion("prodEng =", value, "prodeng");
            return (Criteria) this;
        }

        public Criteria andProdengNotEqualTo(String value) {
            addCriterion("prodEng <>", value, "prodeng");
            return (Criteria) this;
        }

        public Criteria andProdengGreaterThan(String value) {
            addCriterion("prodEng >", value, "prodeng");
            return (Criteria) this;
        }

        public Criteria andProdengGreaterThanOrEqualTo(String value) {
            addCriterion("prodEng >=", value, "prodeng");
            return (Criteria) this;
        }

        public Criteria andProdengLessThan(String value) {
            addCriterion("prodEng <", value, "prodeng");
            return (Criteria) this;
        }

        public Criteria andProdengLessThanOrEqualTo(String value) {
            addCriterion("prodEng <=", value, "prodeng");
            return (Criteria) this;
        }

        public Criteria andProdengLike(String value) {
            addCriterion("prodEng like", value, "prodeng");
            return (Criteria) this;
        }

        public Criteria andProdengNotLike(String value) {
            addCriterion("prodEng not like", value, "prodeng");
            return (Criteria) this;
        }

        public Criteria andProdengIn(List<String> values) {
            addCriterion("prodEng in", values, "prodeng");
            return (Criteria) this;
        }

        public Criteria andProdengNotIn(List<String> values) {
            addCriterion("prodEng not in", values, "prodeng");
            return (Criteria) this;
        }

        public Criteria andProdengBetween(String value1, String value2) {
            addCriterion("prodEng between", value1, value2, "prodeng");
            return (Criteria) this;
        }

        public Criteria andProdengNotBetween(String value1, String value2) {
            addCriterion("prodEng not between", value1, value2, "prodeng");
            return (Criteria) this;
        }

        public Criteria andSizecodeIsNull() {
            addCriterion("sizeCode is null");
            return (Criteria) this;
        }

        public Criteria andSizecodeIsNotNull() {
            addCriterion("sizeCode is not null");
            return (Criteria) this;
        }

        public Criteria andSizecodeEqualTo(String value) {
            addCriterion("sizeCode =", value, "sizecode");
            return (Criteria) this;
        }

        public Criteria andSizecodeNotEqualTo(String value) {
            addCriterion("sizeCode <>", value, "sizecode");
            return (Criteria) this;
        }

        public Criteria andSizecodeGreaterThan(String value) {
            addCriterion("sizeCode >", value, "sizecode");
            return (Criteria) this;
        }

        public Criteria andSizecodeGreaterThanOrEqualTo(String value) {
            addCriterion("sizeCode >=", value, "sizecode");
            return (Criteria) this;
        }

        public Criteria andSizecodeLessThan(String value) {
            addCriterion("sizeCode <", value, "sizecode");
            return (Criteria) this;
        }

        public Criteria andSizecodeLessThanOrEqualTo(String value) {
            addCriterion("sizeCode <=", value, "sizecode");
            return (Criteria) this;
        }

        public Criteria andSizecodeLike(String value) {
            addCriterion("sizeCode like", value, "sizecode");
            return (Criteria) this;
        }

        public Criteria andSizecodeNotLike(String value) {
            addCriterion("sizeCode not like", value, "sizecode");
            return (Criteria) this;
        }

        public Criteria andSizecodeIn(List<String> values) {
            addCriterion("sizeCode in", values, "sizecode");
            return (Criteria) this;
        }

        public Criteria andSizecodeNotIn(List<String> values) {
            addCriterion("sizeCode not in", values, "sizecode");
            return (Criteria) this;
        }

        public Criteria andSizecodeBetween(String value1, String value2) {
            addCriterion("sizeCode between", value1, value2, "sizecode");
            return (Criteria) this;
        }

        public Criteria andSizecodeNotBetween(String value1, String value2) {
            addCriterion("sizeCode not between", value1, value2, "sizecode");
            return (Criteria) this;
        }

        public Criteria andColorcodeIsNull() {
            addCriterion("colorCode is null");
            return (Criteria) this;
        }

        public Criteria andColorcodeIsNotNull() {
            addCriterion("colorCode is not null");
            return (Criteria) this;
        }

        public Criteria andColorcodeEqualTo(String value) {
            addCriterion("colorCode =", value, "colorcode");
            return (Criteria) this;
        }

        public Criteria andColorcodeNotEqualTo(String value) {
            addCriterion("colorCode <>", value, "colorcode");
            return (Criteria) this;
        }

        public Criteria andColorcodeGreaterThan(String value) {
            addCriterion("colorCode >", value, "colorcode");
            return (Criteria) this;
        }

        public Criteria andColorcodeGreaterThanOrEqualTo(String value) {
            addCriterion("colorCode >=", value, "colorcode");
            return (Criteria) this;
        }

        public Criteria andColorcodeLessThan(String value) {
            addCriterion("colorCode <", value, "colorcode");
            return (Criteria) this;
        }

        public Criteria andColorcodeLessThanOrEqualTo(String value) {
            addCriterion("colorCode <=", value, "colorcode");
            return (Criteria) this;
        }

        public Criteria andColorcodeLike(String value) {
            addCriterion("colorCode like", value, "colorcode");
            return (Criteria) this;
        }

        public Criteria andColorcodeNotLike(String value) {
            addCriterion("colorCode not like", value, "colorcode");
            return (Criteria) this;
        }

        public Criteria andColorcodeIn(List<String> values) {
            addCriterion("colorCode in", values, "colorcode");
            return (Criteria) this;
        }

        public Criteria andColorcodeNotIn(List<String> values) {
            addCriterion("colorCode not in", values, "colorcode");
            return (Criteria) this;
        }

        public Criteria andColorcodeBetween(String value1, String value2) {
            addCriterion("colorCode between", value1, value2, "colorcode");
            return (Criteria) this;
        }

        public Criteria andColorcodeNotBetween(String value1, String value2) {
            addCriterion("colorCode not between", value1, value2, "colorcode");
            return (Criteria) this;
        }

        public Criteria andInpriceIsNull() {
            addCriterion("inPrice is null");
            return (Criteria) this;
        }

        public Criteria andInpriceIsNotNull() {
            addCriterion("inPrice is not null");
            return (Criteria) this;
        }

        public Criteria andInpriceEqualTo(BigDecimal value) {
            addCriterion("inPrice =", value, "inprice");
            return (Criteria) this;
        }

        public Criteria andInpriceNotEqualTo(BigDecimal value) {
            addCriterion("inPrice <>", value, "inprice");
            return (Criteria) this;
        }

        public Criteria andInpriceGreaterThan(BigDecimal value) {
            addCriterion("inPrice >", value, "inprice");
            return (Criteria) this;
        }

        public Criteria andInpriceGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("inPrice >=", value, "inprice");
            return (Criteria) this;
        }

        public Criteria andInpriceLessThan(BigDecimal value) {
            addCriterion("inPrice <", value, "inprice");
            return (Criteria) this;
        }

        public Criteria andInpriceLessThanOrEqualTo(BigDecimal value) {
            addCriterion("inPrice <=", value, "inprice");
            return (Criteria) this;
        }

        public Criteria andInpriceIn(List<BigDecimal> values) {
            addCriterion("inPrice in", values, "inprice");
            return (Criteria) this;
        }

        public Criteria andInpriceNotIn(List<BigDecimal> values) {
            addCriterion("inPrice not in", values, "inprice");
            return (Criteria) this;
        }

        public Criteria andInpriceBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("inPrice between", value1, value2, "inprice");
            return (Criteria) this;
        }

        public Criteria andInpriceNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("inPrice not between", value1, value2, "inprice");
            return (Criteria) this;
        }

        public Criteria andSalepriceIsNull() {
            addCriterion("salePrice is null");
            return (Criteria) this;
        }

        public Criteria andSalepriceIsNotNull() {
            addCriterion("salePrice is not null");
            return (Criteria) this;
        }

        public Criteria andSalepriceEqualTo(BigDecimal value) {
            addCriterion("salePrice =", value, "saleprice");
            return (Criteria) this;
        }

        public Criteria andSalepriceNotEqualTo(BigDecimal value) {
            addCriterion("salePrice <>", value, "saleprice");
            return (Criteria) this;
        }

        public Criteria andSalepriceGreaterThan(BigDecimal value) {
            addCriterion("salePrice >", value, "saleprice");
            return (Criteria) this;
        }

        public Criteria andSalepriceGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("salePrice >=", value, "saleprice");
            return (Criteria) this;
        }

        public Criteria andSalepriceLessThan(BigDecimal value) {
            addCriterion("salePrice <", value, "saleprice");
            return (Criteria) this;
        }

        public Criteria andSalepriceLessThanOrEqualTo(BigDecimal value) {
            addCriterion("salePrice <=", value, "saleprice");
            return (Criteria) this;
        }

        public Criteria andSalepriceIn(List<BigDecimal> values) {
            addCriterion("salePrice in", values, "saleprice");
            return (Criteria) this;
        }

        public Criteria andSalepriceNotIn(List<BigDecimal> values) {
            addCriterion("salePrice not in", values, "saleprice");
            return (Criteria) this;
        }

        public Criteria andSalepriceBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("salePrice between", value1, value2, "saleprice");
            return (Criteria) this;
        }

        public Criteria andSalepriceNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("salePrice not between", value1, value2, "saleprice");
            return (Criteria) this;
        }

        public Criteria andCogpriceIsNull() {
            addCriterion("cogPrice is null");
            return (Criteria) this;
        }

        public Criteria andCogpriceIsNotNull() {
            addCriterion("cogPrice is not null");
            return (Criteria) this;
        }

        public Criteria andCogpriceEqualTo(BigDecimal value) {
            addCriterion("cogPrice =", value, "cogprice");
            return (Criteria) this;
        }

        public Criteria andCogpriceNotEqualTo(BigDecimal value) {
            addCriterion("cogPrice <>", value, "cogprice");
            return (Criteria) this;
        }

        public Criteria andCogpriceGreaterThan(BigDecimal value) {
            addCriterion("cogPrice >", value, "cogprice");
            return (Criteria) this;
        }

        public Criteria andCogpriceGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("cogPrice >=", value, "cogprice");
            return (Criteria) this;
        }

        public Criteria andCogpriceLessThan(BigDecimal value) {
            addCriterion("cogPrice <", value, "cogprice");
            return (Criteria) this;
        }

        public Criteria andCogpriceLessThanOrEqualTo(BigDecimal value) {
            addCriterion("cogPrice <=", value, "cogprice");
            return (Criteria) this;
        }

        public Criteria andCogpriceIn(List<BigDecimal> values) {
            addCriterion("cogPrice in", values, "cogprice");
            return (Criteria) this;
        }

        public Criteria andCogpriceNotIn(List<BigDecimal> values) {
            addCriterion("cogPrice not in", values, "cogprice");
            return (Criteria) this;
        }

        public Criteria andCogpriceBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("cogPrice between", value1, value2, "cogprice");
            return (Criteria) this;
        }

        public Criteria andCogpriceNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("cogPrice not between", value1, value2, "cogprice");
            return (Criteria) this;
        }

        public Criteria andCyhinpriceIsNull() {
            addCriterion("cyhInPrice is null");
            return (Criteria) this;
        }

        public Criteria andCyhinpriceIsNotNull() {
            addCriterion("cyhInPrice is not null");
            return (Criteria) this;
        }

        public Criteria andCyhinpriceEqualTo(BigDecimal value) {
            addCriterion("cyhInPrice =", value, "cyhinprice");
            return (Criteria) this;
        }

        public Criteria andCyhinpriceNotEqualTo(BigDecimal value) {
            addCriterion("cyhInPrice <>", value, "cyhinprice");
            return (Criteria) this;
        }

        public Criteria andCyhinpriceGreaterThan(BigDecimal value) {
            addCriterion("cyhInPrice >", value, "cyhinprice");
            return (Criteria) this;
        }

        public Criteria andCyhinpriceGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("cyhInPrice >=", value, "cyhinprice");
            return (Criteria) this;
        }

        public Criteria andCyhinpriceLessThan(BigDecimal value) {
            addCriterion("cyhInPrice <", value, "cyhinprice");
            return (Criteria) this;
        }

        public Criteria andCyhinpriceLessThanOrEqualTo(BigDecimal value) {
            addCriterion("cyhInPrice <=", value, "cyhinprice");
            return (Criteria) this;
        }

        public Criteria andCyhinpriceIn(List<BigDecimal> values) {
            addCriterion("cyhInPrice in", values, "cyhinprice");
            return (Criteria) this;
        }

        public Criteria andCyhinpriceNotIn(List<BigDecimal> values) {
            addCriterion("cyhInPrice not in", values, "cyhinprice");
            return (Criteria) this;
        }

        public Criteria andCyhinpriceBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("cyhInPrice between", value1, value2, "cyhinprice");
            return (Criteria) this;
        }

        public Criteria andCyhinpriceNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("cyhInPrice not between", value1, value2, "cyhinprice");
            return (Criteria) this;
        }

        public Criteria andCyhsalepriceIsNull() {
            addCriterion("cyhSalePrice is null");
            return (Criteria) this;
        }

        public Criteria andCyhsalepriceIsNotNull() {
            addCriterion("cyhSalePrice is not null");
            return (Criteria) this;
        }

        public Criteria andCyhsalepriceEqualTo(BigDecimal value) {
            addCriterion("cyhSalePrice =", value, "cyhsaleprice");
            return (Criteria) this;
        }

        public Criteria andCyhsalepriceNotEqualTo(BigDecimal value) {
            addCriterion("cyhSalePrice <>", value, "cyhsaleprice");
            return (Criteria) this;
        }

        public Criteria andCyhsalepriceGreaterThan(BigDecimal value) {
            addCriterion("cyhSalePrice >", value, "cyhsaleprice");
            return (Criteria) this;
        }

        public Criteria andCyhsalepriceGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("cyhSalePrice >=", value, "cyhsaleprice");
            return (Criteria) this;
        }

        public Criteria andCyhsalepriceLessThan(BigDecimal value) {
            addCriterion("cyhSalePrice <", value, "cyhsaleprice");
            return (Criteria) this;
        }

        public Criteria andCyhsalepriceLessThanOrEqualTo(BigDecimal value) {
            addCriterion("cyhSalePrice <=", value, "cyhsaleprice");
            return (Criteria) this;
        }

        public Criteria andCyhsalepriceIn(List<BigDecimal> values) {
            addCriterion("cyhSalePrice in", values, "cyhsaleprice");
            return (Criteria) this;
        }

        public Criteria andCyhsalepriceNotIn(List<BigDecimal> values) {
            addCriterion("cyhSalePrice not in", values, "cyhsaleprice");
            return (Criteria) this;
        }

        public Criteria andCyhsalepriceBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("cyhSalePrice between", value1, value2, "cyhsaleprice");
            return (Criteria) this;
        }

        public Criteria andCyhsalepriceNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("cyhSalePrice not between", value1, value2, "cyhsaleprice");
            return (Criteria) this;
        }

        public Criteria andProvidersecondIsNull() {
            addCriterion("providerSecond is null");
            return (Criteria) this;
        }

        public Criteria andProvidersecondIsNotNull() {
            addCriterion("providerSecond is not null");
            return (Criteria) this;
        }

        public Criteria andProvidersecondEqualTo(String value) {
            addCriterion("providerSecond =", value, "providersecond");
            return (Criteria) this;
        }

        public Criteria andProvidersecondNotEqualTo(String value) {
            addCriterion("providerSecond <>", value, "providersecond");
            return (Criteria) this;
        }

        public Criteria andProvidersecondGreaterThan(String value) {
            addCriterion("providerSecond >", value, "providersecond");
            return (Criteria) this;
        }

        public Criteria andProvidersecondGreaterThanOrEqualTo(String value) {
            addCriterion("providerSecond >=", value, "providersecond");
            return (Criteria) this;
        }

        public Criteria andProvidersecondLessThan(String value) {
            addCriterion("providerSecond <", value, "providersecond");
            return (Criteria) this;
        }

        public Criteria andProvidersecondLessThanOrEqualTo(String value) {
            addCriterion("providerSecond <=", value, "providersecond");
            return (Criteria) this;
        }

        public Criteria andProvidersecondLike(String value) {
            addCriterion("providerSecond like", value, "providersecond");
            return (Criteria) this;
        }

        public Criteria andProvidersecondNotLike(String value) {
            addCriterion("providerSecond not like", value, "providersecond");
            return (Criteria) this;
        }

        public Criteria andProvidersecondIn(List<String> values) {
            addCriterion("providerSecond in", values, "providersecond");
            return (Criteria) this;
        }

        public Criteria andProvidersecondNotIn(List<String> values) {
            addCriterion("providerSecond not in", values, "providersecond");
            return (Criteria) this;
        }

        public Criteria andProvidersecondBetween(String value1, String value2) {
            addCriterion("providerSecond between", value1, value2, "providersecond");
            return (Criteria) this;
        }

        public Criteria andProvidersecondNotBetween(String value1, String value2) {
            addCriterion("providerSecond not between", value1, value2, "providersecond");
            return (Criteria) this;
        }

        public Criteria andLowstoreIsNull() {
            addCriterion("lowStore is null");
            return (Criteria) this;
        }

        public Criteria andLowstoreIsNotNull() {
            addCriterion("lowStore is not null");
            return (Criteria) this;
        }

        public Criteria andLowstoreEqualTo(Integer value) {
            addCriterion("lowStore =", value, "lowstore");
            return (Criteria) this;
        }

        public Criteria andLowstoreNotEqualTo(Integer value) {
            addCriterion("lowStore <>", value, "lowstore");
            return (Criteria) this;
        }

        public Criteria andLowstoreGreaterThan(Integer value) {
            addCriterion("lowStore >", value, "lowstore");
            return (Criteria) this;
        }

        public Criteria andLowstoreGreaterThanOrEqualTo(Integer value) {
            addCriterion("lowStore >=", value, "lowstore");
            return (Criteria) this;
        }

        public Criteria andLowstoreLessThan(Integer value) {
            addCriterion("lowStore <", value, "lowstore");
            return (Criteria) this;
        }

        public Criteria andLowstoreLessThanOrEqualTo(Integer value) {
            addCriterion("lowStore <=", value, "lowstore");
            return (Criteria) this;
        }

        public Criteria andLowstoreIn(List<Integer> values) {
            addCriterion("lowStore in", values, "lowstore");
            return (Criteria) this;
        }

        public Criteria andLowstoreNotIn(List<Integer> values) {
            addCriterion("lowStore not in", values, "lowstore");
            return (Criteria) this;
        }

        public Criteria andLowstoreBetween(Integer value1, Integer value2) {
            addCriterion("lowStore between", value1, value2, "lowstore");
            return (Criteria) this;
        }

        public Criteria andLowstoreNotBetween(Integer value1, Integer value2) {
            addCriterion("lowStore not between", value1, value2, "lowstore");
            return (Criteria) this;
        }

        public Criteria andHighstoreIsNull() {
            addCriterion("highStore is null");
            return (Criteria) this;
        }

        public Criteria andHighstoreIsNotNull() {
            addCriterion("highStore is not null");
            return (Criteria) this;
        }

        public Criteria andHighstoreEqualTo(Integer value) {
            addCriterion("highStore =", value, "highstore");
            return (Criteria) this;
        }

        public Criteria andHighstoreNotEqualTo(Integer value) {
            addCriterion("highStore <>", value, "highstore");
            return (Criteria) this;
        }

        public Criteria andHighstoreGreaterThan(Integer value) {
            addCriterion("highStore >", value, "highstore");
            return (Criteria) this;
        }

        public Criteria andHighstoreGreaterThanOrEqualTo(Integer value) {
            addCriterion("highStore >=", value, "highstore");
            return (Criteria) this;
        }

        public Criteria andHighstoreLessThan(Integer value) {
            addCriterion("highStore <", value, "highstore");
            return (Criteria) this;
        }

        public Criteria andHighstoreLessThanOrEqualTo(Integer value) {
            addCriterion("highStore <=", value, "highstore");
            return (Criteria) this;
        }

        public Criteria andHighstoreIn(List<Integer> values) {
            addCriterion("highStore in", values, "highstore");
            return (Criteria) this;
        }

        public Criteria andHighstoreNotIn(List<Integer> values) {
            addCriterion("highStore not in", values, "highstore");
            return (Criteria) this;
        }

        public Criteria andHighstoreBetween(Integer value1, Integer value2) {
            addCriterion("highStore between", value1, value2, "highstore");
            return (Criteria) this;
        }

        public Criteria andHighstoreNotBetween(Integer value1, Integer value2) {
            addCriterion("highStore not between", value1, value2, "highstore");
            return (Criteria) this;
        }

        public Criteria andIsserviceIsNull() {
            addCriterion("isService is null");
            return (Criteria) this;
        }

        public Criteria andIsserviceIsNotNull() {
            addCriterion("isService is not null");
            return (Criteria) this;
        }

        public Criteria andIsserviceEqualTo(String value) {
            addCriterion("isService =", value, "isservice");
            return (Criteria) this;
        }

        public Criteria andIsserviceNotEqualTo(String value) {
            addCriterion("isService <>", value, "isservice");
            return (Criteria) this;
        }

        public Criteria andIsserviceGreaterThan(String value) {
            addCriterion("isService >", value, "isservice");
            return (Criteria) this;
        }

        public Criteria andIsserviceGreaterThanOrEqualTo(String value) {
            addCriterion("isService >=", value, "isservice");
            return (Criteria) this;
        }

        public Criteria andIsserviceLessThan(String value) {
            addCriterion("isService <", value, "isservice");
            return (Criteria) this;
        }

        public Criteria andIsserviceLessThanOrEqualTo(String value) {
            addCriterion("isService <=", value, "isservice");
            return (Criteria) this;
        }

        public Criteria andIsserviceLike(String value) {
            addCriterion("isService like", value, "isservice");
            return (Criteria) this;
        }

        public Criteria andIsserviceNotLike(String value) {
            addCriterion("isService not like", value, "isservice");
            return (Criteria) this;
        }

        public Criteria andIsserviceIn(List<String> values) {
            addCriterion("isService in", values, "isservice");
            return (Criteria) this;
        }

        public Criteria andIsserviceNotIn(List<String> values) {
            addCriterion("isService not in", values, "isservice");
            return (Criteria) this;
        }

        public Criteria andIsserviceBetween(String value1, String value2) {
            addCriterion("isService between", value1, value2, "isservice");
            return (Criteria) this;
        }

        public Criteria andIsserviceNotBetween(String value1, String value2) {
            addCriterion("isService not between", value1, value2, "isservice");
            return (Criteria) this;
        }

        public Criteria andIsbindIsNull() {
            addCriterion("isBind is null");
            return (Criteria) this;
        }

        public Criteria andIsbindIsNotNull() {
            addCriterion("isBind is not null");
            return (Criteria) this;
        }

        public Criteria andIsbindEqualTo(String value) {
            addCriterion("isBind =", value, "isbind");
            return (Criteria) this;
        }

        public Criteria andIsbindNotEqualTo(String value) {
            addCriterion("isBind <>", value, "isbind");
            return (Criteria) this;
        }

        public Criteria andIsbindGreaterThan(String value) {
            addCriterion("isBind >", value, "isbind");
            return (Criteria) this;
        }

        public Criteria andIsbindGreaterThanOrEqualTo(String value) {
            addCriterion("isBind >=", value, "isbind");
            return (Criteria) this;
        }

        public Criteria andIsbindLessThan(String value) {
            addCriterion("isBind <", value, "isbind");
            return (Criteria) this;
        }

        public Criteria andIsbindLessThanOrEqualTo(String value) {
            addCriterion("isBind <=", value, "isbind");
            return (Criteria) this;
        }

        public Criteria andIsbindLike(String value) {
            addCriterion("isBind like", value, "isbind");
            return (Criteria) this;
        }

        public Criteria andIsbindNotLike(String value) {
            addCriterion("isBind not like", value, "isbind");
            return (Criteria) this;
        }

        public Criteria andIsbindIn(List<String> values) {
            addCriterion("isBind in", values, "isbind");
            return (Criteria) this;
        }

        public Criteria andIsbindNotIn(List<String> values) {
            addCriterion("isBind not in", values, "isbind");
            return (Criteria) this;
        }

        public Criteria andIsbindBetween(String value1, String value2) {
            addCriterion("isBind between", value1, value2, "isbind");
            return (Criteria) this;
        }

        public Criteria andIsbindNotBetween(String value1, String value2) {
            addCriterion("isBind not between", value1, value2, "isbind");
            return (Criteria) this;
        }

        public Criteria andIsspecialIsNull() {
            addCriterion("isSpecial is null");
            return (Criteria) this;
        }

        public Criteria andIsspecialIsNotNull() {
            addCriterion("isSpecial is not null");
            return (Criteria) this;
        }

        public Criteria andIsspecialEqualTo(String value) {
            addCriterion("isSpecial =", value, "isspecial");
            return (Criteria) this;
        }

        public Criteria andIsspecialNotEqualTo(String value) {
            addCriterion("isSpecial <>", value, "isspecial");
            return (Criteria) this;
        }

        public Criteria andIsspecialGreaterThan(String value) {
            addCriterion("isSpecial >", value, "isspecial");
            return (Criteria) this;
        }

        public Criteria andIsspecialGreaterThanOrEqualTo(String value) {
            addCriterion("isSpecial >=", value, "isspecial");
            return (Criteria) this;
        }

        public Criteria andIsspecialLessThan(String value) {
            addCriterion("isSpecial <", value, "isspecial");
            return (Criteria) this;
        }

        public Criteria andIsspecialLessThanOrEqualTo(String value) {
            addCriterion("isSpecial <=", value, "isspecial");
            return (Criteria) this;
        }

        public Criteria andIsspecialLike(String value) {
            addCriterion("isSpecial like", value, "isspecial");
            return (Criteria) this;
        }

        public Criteria andIsspecialNotLike(String value) {
            addCriterion("isSpecial not like", value, "isspecial");
            return (Criteria) this;
        }

        public Criteria andIsspecialIn(List<String> values) {
            addCriterion("isSpecial in", values, "isspecial");
            return (Criteria) this;
        }

        public Criteria andIsspecialNotIn(List<String> values) {
            addCriterion("isSpecial not in", values, "isspecial");
            return (Criteria) this;
        }

        public Criteria andIsspecialBetween(String value1, String value2) {
            addCriterion("isSpecial between", value1, value2, "isspecial");
            return (Criteria) this;
        }

        public Criteria andIsspecialNotBetween(String value1, String value2) {
            addCriterion("isSpecial not between", value1, value2, "isspecial");
            return (Criteria) this;
        }

        public Criteria andBigunitcodeIsNull() {
            addCriterion("bigUnitCode is null");
            return (Criteria) this;
        }

        public Criteria andBigunitcodeIsNotNull() {
            addCriterion("bigUnitCode is not null");
            return (Criteria) this;
        }

        public Criteria andBigunitcodeEqualTo(String value) {
            addCriterion("bigUnitCode =", value, "bigunitcode");
            return (Criteria) this;
        }

        public Criteria andBigunitcodeNotEqualTo(String value) {
            addCriterion("bigUnitCode <>", value, "bigunitcode");
            return (Criteria) this;
        }

        public Criteria andBigunitcodeGreaterThan(String value) {
            addCriterion("bigUnitCode >", value, "bigunitcode");
            return (Criteria) this;
        }

        public Criteria andBigunitcodeGreaterThanOrEqualTo(String value) {
            addCriterion("bigUnitCode >=", value, "bigunitcode");
            return (Criteria) this;
        }

        public Criteria andBigunitcodeLessThan(String value) {
            addCriterion("bigUnitCode <", value, "bigunitcode");
            return (Criteria) this;
        }

        public Criteria andBigunitcodeLessThanOrEqualTo(String value) {
            addCriterion("bigUnitCode <=", value, "bigunitcode");
            return (Criteria) this;
        }

        public Criteria andBigunitcodeLike(String value) {
            addCriterion("bigUnitCode like", value, "bigunitcode");
            return (Criteria) this;
        }

        public Criteria andBigunitcodeNotLike(String value) {
            addCriterion("bigUnitCode not like", value, "bigunitcode");
            return (Criteria) this;
        }

        public Criteria andBigunitcodeIn(List<String> values) {
            addCriterion("bigUnitCode in", values, "bigunitcode");
            return (Criteria) this;
        }

        public Criteria andBigunitcodeNotIn(List<String> values) {
            addCriterion("bigUnitCode not in", values, "bigunitcode");
            return (Criteria) this;
        }

        public Criteria andBigunitcodeBetween(String value1, String value2) {
            addCriterion("bigUnitCode between", value1, value2, "bigunitcode");
            return (Criteria) this;
        }

        public Criteria andBigunitcodeNotBetween(String value1, String value2) {
            addCriterion("bigUnitCode not between", value1, value2, "bigunitcode");
            return (Criteria) this;
        }

        public Criteria andBasicunitcodeIsNull() {
            addCriterion("BasicUnitCode is null");
            return (Criteria) this;
        }

        public Criteria andBasicunitcodeIsNotNull() {
            addCriterion("BasicUnitCode is not null");
            return (Criteria) this;
        }

        public Criteria andBasicunitcodeEqualTo(String value) {
            addCriterion("BasicUnitCode =", value, "basicunitcode");
            return (Criteria) this;
        }

        public Criteria andBasicunitcodeNotEqualTo(String value) {
            addCriterion("BasicUnitCode <>", value, "basicunitcode");
            return (Criteria) this;
        }

        public Criteria andBasicunitcodeGreaterThan(String value) {
            addCriterion("BasicUnitCode >", value, "basicunitcode");
            return (Criteria) this;
        }

        public Criteria andBasicunitcodeGreaterThanOrEqualTo(String value) {
            addCriterion("BasicUnitCode >=", value, "basicunitcode");
            return (Criteria) this;
        }

        public Criteria andBasicunitcodeLessThan(String value) {
            addCriterion("BasicUnitCode <", value, "basicunitcode");
            return (Criteria) this;
        }

        public Criteria andBasicunitcodeLessThanOrEqualTo(String value) {
            addCriterion("BasicUnitCode <=", value, "basicunitcode");
            return (Criteria) this;
        }

        public Criteria andBasicunitcodeLike(String value) {
            addCriterion("BasicUnitCode like", value, "basicunitcode");
            return (Criteria) this;
        }

        public Criteria andBasicunitcodeNotLike(String value) {
            addCriterion("BasicUnitCode not like", value, "basicunitcode");
            return (Criteria) this;
        }

        public Criteria andBasicunitcodeIn(List<String> values) {
            addCriterion("BasicUnitCode in", values, "basicunitcode");
            return (Criteria) this;
        }

        public Criteria andBasicunitcodeNotIn(List<String> values) {
            addCriterion("BasicUnitCode not in", values, "basicunitcode");
            return (Criteria) this;
        }

        public Criteria andBasicunitcodeBetween(String value1, String value2) {
            addCriterion("BasicUnitCode between", value1, value2, "basicunitcode");
            return (Criteria) this;
        }

        public Criteria andBasicunitcodeNotBetween(String value1, String value2) {
            addCriterion("BasicUnitCode not between", value1, value2, "basicunitcode");
            return (Criteria) this;
        }

        public Criteria andInnumIsNull() {
            addCriterion("inNum is null");
            return (Criteria) this;
        }

        public Criteria andInnumIsNotNull() {
            addCriterion("inNum is not null");
            return (Criteria) this;
        }

        public Criteria andInnumEqualTo(Integer value) {
            addCriterion("inNum =", value, "innum");
            return (Criteria) this;
        }

        public Criteria andInnumNotEqualTo(Integer value) {
            addCriterion("inNum <>", value, "innum");
            return (Criteria) this;
        }

        public Criteria andInnumGreaterThan(Integer value) {
            addCriterion("inNum >", value, "innum");
            return (Criteria) this;
        }

        public Criteria andInnumGreaterThanOrEqualTo(Integer value) {
            addCriterion("inNum >=", value, "innum");
            return (Criteria) this;
        }

        public Criteria andInnumLessThan(Integer value) {
            addCriterion("inNum <", value, "innum");
            return (Criteria) this;
        }

        public Criteria andInnumLessThanOrEqualTo(Integer value) {
            addCriterion("inNum <=", value, "innum");
            return (Criteria) this;
        }

        public Criteria andInnumIn(List<Integer> values) {
            addCriterion("inNum in", values, "innum");
            return (Criteria) this;
        }

        public Criteria andInnumNotIn(List<Integer> values) {
            addCriterion("inNum not in", values, "innum");
            return (Criteria) this;
        }

        public Criteria andInnumBetween(Integer value1, Integer value2) {
            addCriterion("inNum between", value1, value2, "innum");
            return (Criteria) this;
        }

        public Criteria andInnumNotBetween(Integer value1, Integer value2) {
            addCriterion("inNum not between", value1, value2, "innum");
            return (Criteria) this;
        }

        public Criteria andProdfromIsNull() {
            addCriterion("prodFrom is null");
            return (Criteria) this;
        }

        public Criteria andProdfromIsNotNull() {
            addCriterion("prodFrom is not null");
            return (Criteria) this;
        }

        public Criteria andProdfromEqualTo(String value) {
            addCriterion("prodFrom =", value, "prodfrom");
            return (Criteria) this;
        }

        public Criteria andProdfromNotEqualTo(String value) {
            addCriterion("prodFrom <>", value, "prodfrom");
            return (Criteria) this;
        }

        public Criteria andProdfromGreaterThan(String value) {
            addCriterion("prodFrom >", value, "prodfrom");
            return (Criteria) this;
        }

        public Criteria andProdfromGreaterThanOrEqualTo(String value) {
            addCriterion("prodFrom >=", value, "prodfrom");
            return (Criteria) this;
        }

        public Criteria andProdfromLessThan(String value) {
            addCriterion("prodFrom <", value, "prodfrom");
            return (Criteria) this;
        }

        public Criteria andProdfromLessThanOrEqualTo(String value) {
            addCriterion("prodFrom <=", value, "prodfrom");
            return (Criteria) this;
        }

        public Criteria andProdfromLike(String value) {
            addCriterion("prodFrom like", value, "prodfrom");
            return (Criteria) this;
        }

        public Criteria andProdfromNotLike(String value) {
            addCriterion("prodFrom not like", value, "prodfrom");
            return (Criteria) this;
        }

        public Criteria andProdfromIn(List<String> values) {
            addCriterion("prodFrom in", values, "prodfrom");
            return (Criteria) this;
        }

        public Criteria andProdfromNotIn(List<String> values) {
            addCriterion("prodFrom not in", values, "prodfrom");
            return (Criteria) this;
        }

        public Criteria andProdfromBetween(String value1, String value2) {
            addCriterion("prodFrom between", value1, value2, "prodfrom");
            return (Criteria) this;
        }

        public Criteria andProdfromNotBetween(String value1, String value2) {
            addCriterion("prodFrom not between", value1, value2, "prodfrom");
            return (Criteria) this;
        }

        public Criteria andFactoryIsNull() {
            addCriterion("factory is null");
            return (Criteria) this;
        }

        public Criteria andFactoryIsNotNull() {
            addCriterion("factory is not null");
            return (Criteria) this;
        }

        public Criteria andFactoryEqualTo(String value) {
            addCriterion("factory =", value, "factory");
            return (Criteria) this;
        }

        public Criteria andFactoryNotEqualTo(String value) {
            addCriterion("factory <>", value, "factory");
            return (Criteria) this;
        }

        public Criteria andFactoryGreaterThan(String value) {
            addCriterion("factory >", value, "factory");
            return (Criteria) this;
        }

        public Criteria andFactoryGreaterThanOrEqualTo(String value) {
            addCriterion("factory >=", value, "factory");
            return (Criteria) this;
        }

        public Criteria andFactoryLessThan(String value) {
            addCriterion("factory <", value, "factory");
            return (Criteria) this;
        }

        public Criteria andFactoryLessThanOrEqualTo(String value) {
            addCriterion("factory <=", value, "factory");
            return (Criteria) this;
        }

        public Criteria andFactoryLike(String value) {
            addCriterion("factory like", value, "factory");
            return (Criteria) this;
        }

        public Criteria andFactoryNotLike(String value) {
            addCriterion("factory not like", value, "factory");
            return (Criteria) this;
        }

        public Criteria andFactoryIn(List<String> values) {
            addCriterion("factory in", values, "factory");
            return (Criteria) this;
        }

        public Criteria andFactoryNotIn(List<String> values) {
            addCriterion("factory not in", values, "factory");
            return (Criteria) this;
        }

        public Criteria andFactoryBetween(String value1, String value2) {
            addCriterion("factory between", value1, value2, "factory");
            return (Criteria) this;
        }

        public Criteria andFactoryNotBetween(String value1, String value2) {
            addCriterion("factory not between", value1, value2, "factory");
            return (Criteria) this;
        }

        public Criteria andRankcodeIsNull() {
            addCriterion("rankCode is null");
            return (Criteria) this;
        }

        public Criteria andRankcodeIsNotNull() {
            addCriterion("rankCode is not null");
            return (Criteria) this;
        }

        public Criteria andRankcodeEqualTo(String value) {
            addCriterion("rankCode =", value, "rankcode");
            return (Criteria) this;
        }

        public Criteria andRankcodeNotEqualTo(String value) {
            addCriterion("rankCode <>", value, "rankcode");
            return (Criteria) this;
        }

        public Criteria andRankcodeGreaterThan(String value) {
            addCriterion("rankCode >", value, "rankcode");
            return (Criteria) this;
        }

        public Criteria andRankcodeGreaterThanOrEqualTo(String value) {
            addCriterion("rankCode >=", value, "rankcode");
            return (Criteria) this;
        }

        public Criteria andRankcodeLessThan(String value) {
            addCriterion("rankCode <", value, "rankcode");
            return (Criteria) this;
        }

        public Criteria andRankcodeLessThanOrEqualTo(String value) {
            addCriterion("rankCode <=", value, "rankcode");
            return (Criteria) this;
        }

        public Criteria andRankcodeLike(String value) {
            addCriterion("rankCode like", value, "rankcode");
            return (Criteria) this;
        }

        public Criteria andRankcodeNotLike(String value) {
            addCriterion("rankCode not like", value, "rankcode");
            return (Criteria) this;
        }

        public Criteria andRankcodeIn(List<String> values) {
            addCriterion("rankCode in", values, "rankcode");
            return (Criteria) this;
        }

        public Criteria andRankcodeNotIn(List<String> values) {
            addCriterion("rankCode not in", values, "rankcode");
            return (Criteria) this;
        }

        public Criteria andRankcodeBetween(String value1, String value2) {
            addCriterion("rankCode between", value1, value2, "rankcode");
            return (Criteria) this;
        }

        public Criteria andRankcodeNotBetween(String value1, String value2) {
            addCriterion("rankCode not between", value1, value2, "rankcode");
            return (Criteria) this;
        }

        public Criteria andSupplyprodnoIsNull() {
            addCriterion("supplyProdNO is null");
            return (Criteria) this;
        }

        public Criteria andSupplyprodnoIsNotNull() {
            addCriterion("supplyProdNO is not null");
            return (Criteria) this;
        }

        public Criteria andSupplyprodnoEqualTo(String value) {
            addCriterion("supplyProdNO =", value, "supplyprodno");
            return (Criteria) this;
        }

        public Criteria andSupplyprodnoNotEqualTo(String value) {
            addCriterion("supplyProdNO <>", value, "supplyprodno");
            return (Criteria) this;
        }

        public Criteria andSupplyprodnoGreaterThan(String value) {
            addCriterion("supplyProdNO >", value, "supplyprodno");
            return (Criteria) this;
        }

        public Criteria andSupplyprodnoGreaterThanOrEqualTo(String value) {
            addCriterion("supplyProdNO >=", value, "supplyprodno");
            return (Criteria) this;
        }

        public Criteria andSupplyprodnoLessThan(String value) {
            addCriterion("supplyProdNO <", value, "supplyprodno");
            return (Criteria) this;
        }

        public Criteria andSupplyprodnoLessThanOrEqualTo(String value) {
            addCriterion("supplyProdNO <=", value, "supplyprodno");
            return (Criteria) this;
        }

        public Criteria andSupplyprodnoLike(String value) {
            addCriterion("supplyProdNO like", value, "supplyprodno");
            return (Criteria) this;
        }

        public Criteria andSupplyprodnoNotLike(String value) {
            addCriterion("supplyProdNO not like", value, "supplyprodno");
            return (Criteria) this;
        }

        public Criteria andSupplyprodnoIn(List<String> values) {
            addCriterion("supplyProdNO in", values, "supplyprodno");
            return (Criteria) this;
        }

        public Criteria andSupplyprodnoNotIn(List<String> values) {
            addCriterion("supplyProdNO not in", values, "supplyprodno");
            return (Criteria) this;
        }

        public Criteria andSupplyprodnoBetween(String value1, String value2) {
            addCriterion("supplyProdNO between", value1, value2, "supplyprodno");
            return (Criteria) this;
        }

        public Criteria andSupplyprodnoNotBetween(String value1, String value2) {
            addCriterion("supplyProdNO not between", value1, value2, "supplyprodno");
            return (Criteria) this;
        }

        public Criteria andCyhnoIsNull() {
            addCriterion("CYHNO is null");
            return (Criteria) this;
        }

        public Criteria andCyhnoIsNotNull() {
            addCriterion("CYHNO is not null");
            return (Criteria) this;
        }

        public Criteria andCyhnoEqualTo(String value) {
            addCriterion("CYHNO =", value, "cyhno");
            return (Criteria) this;
        }

        public Criteria andCyhnoNotEqualTo(String value) {
            addCriterion("CYHNO <>", value, "cyhno");
            return (Criteria) this;
        }

        public Criteria andCyhnoGreaterThan(String value) {
            addCriterion("CYHNO >", value, "cyhno");
            return (Criteria) this;
        }

        public Criteria andCyhnoGreaterThanOrEqualTo(String value) {
            addCriterion("CYHNO >=", value, "cyhno");
            return (Criteria) this;
        }

        public Criteria andCyhnoLessThan(String value) {
            addCriterion("CYHNO <", value, "cyhno");
            return (Criteria) this;
        }

        public Criteria andCyhnoLessThanOrEqualTo(String value) {
            addCriterion("CYHNO <=", value, "cyhno");
            return (Criteria) this;
        }

        public Criteria andCyhnoLike(String value) {
            addCriterion("CYHNO like", value, "cyhno");
            return (Criteria) this;
        }

        public Criteria andCyhnoNotLike(String value) {
            addCriterion("CYHNO not like", value, "cyhno");
            return (Criteria) this;
        }

        public Criteria andCyhnoIn(List<String> values) {
            addCriterion("CYHNO in", values, "cyhno");
            return (Criteria) this;
        }

        public Criteria andCyhnoNotIn(List<String> values) {
            addCriterion("CYHNO not in", values, "cyhno");
            return (Criteria) this;
        }

        public Criteria andCyhnoBetween(String value1, String value2) {
            addCriterion("CYHNO between", value1, value2, "cyhno");
            return (Criteria) this;
        }

        public Criteria andCyhnoNotBetween(String value1, String value2) {
            addCriterion("CYHNO not between", value1, value2, "cyhno");
            return (Criteria) this;
        }

        public Criteria andSelfprodflgIsNull() {
            addCriterion("selfProdFlg is null");
            return (Criteria) this;
        }

        public Criteria andSelfprodflgIsNotNull() {
            addCriterion("selfProdFlg is not null");
            return (Criteria) this;
        }

        public Criteria andSelfprodflgEqualTo(String value) {
            addCriterion("selfProdFlg =", value, "selfprodflg");
            return (Criteria) this;
        }

        public Criteria andSelfprodflgNotEqualTo(String value) {
            addCriterion("selfProdFlg <>", value, "selfprodflg");
            return (Criteria) this;
        }

        public Criteria andSelfprodflgGreaterThan(String value) {
            addCriterion("selfProdFlg >", value, "selfprodflg");
            return (Criteria) this;
        }

        public Criteria andSelfprodflgGreaterThanOrEqualTo(String value) {
            addCriterion("selfProdFlg >=", value, "selfprodflg");
            return (Criteria) this;
        }

        public Criteria andSelfprodflgLessThan(String value) {
            addCriterion("selfProdFlg <", value, "selfprodflg");
            return (Criteria) this;
        }

        public Criteria andSelfprodflgLessThanOrEqualTo(String value) {
            addCriterion("selfProdFlg <=", value, "selfprodflg");
            return (Criteria) this;
        }

        public Criteria andSelfprodflgLike(String value) {
            addCriterion("selfProdFlg like", value, "selfprodflg");
            return (Criteria) this;
        }

        public Criteria andSelfprodflgNotLike(String value) {
            addCriterion("selfProdFlg not like", value, "selfprodflg");
            return (Criteria) this;
        }

        public Criteria andSelfprodflgIn(List<String> values) {
            addCriterion("selfProdFlg in", values, "selfprodflg");
            return (Criteria) this;
        }

        public Criteria andSelfprodflgNotIn(List<String> values) {
            addCriterion("selfProdFlg not in", values, "selfprodflg");
            return (Criteria) this;
        }

        public Criteria andSelfprodflgBetween(String value1, String value2) {
            addCriterion("selfProdFlg between", value1, value2, "selfprodflg");
            return (Criteria) this;
        }

        public Criteria andSelfprodflgNotBetween(String value1, String value2) {
            addCriterion("selfProdFlg not between", value1, value2, "selfprodflg");
            return (Criteria) this;
        }

        public Criteria andStockendflgIsNull() {
            addCriterion("stockEndFlg is null");
            return (Criteria) this;
        }

        public Criteria andStockendflgIsNotNull() {
            addCriterion("stockEndFlg is not null");
            return (Criteria) this;
        }

        public Criteria andStockendflgEqualTo(String value) {
            addCriterion("stockEndFlg =", value, "stockendflg");
            return (Criteria) this;
        }

        public Criteria andStockendflgNotEqualTo(String value) {
            addCriterion("stockEndFlg <>", value, "stockendflg");
            return (Criteria) this;
        }

        public Criteria andStockendflgGreaterThan(String value) {
            addCriterion("stockEndFlg >", value, "stockendflg");
            return (Criteria) this;
        }

        public Criteria andStockendflgGreaterThanOrEqualTo(String value) {
            addCriterion("stockEndFlg >=", value, "stockendflg");
            return (Criteria) this;
        }

        public Criteria andStockendflgLessThan(String value) {
            addCriterion("stockEndFlg <", value, "stockendflg");
            return (Criteria) this;
        }

        public Criteria andStockendflgLessThanOrEqualTo(String value) {
            addCriterion("stockEndFlg <=", value, "stockendflg");
            return (Criteria) this;
        }

        public Criteria andStockendflgLike(String value) {
            addCriterion("stockEndFlg like", value, "stockendflg");
            return (Criteria) this;
        }

        public Criteria andStockendflgNotLike(String value) {
            addCriterion("stockEndFlg not like", value, "stockendflg");
            return (Criteria) this;
        }

        public Criteria andStockendflgIn(List<String> values) {
            addCriterion("stockEndFlg in", values, "stockendflg");
            return (Criteria) this;
        }

        public Criteria andStockendflgNotIn(List<String> values) {
            addCriterion("stockEndFlg not in", values, "stockendflg");
            return (Criteria) this;
        }

        public Criteria andStockendflgBetween(String value1, String value2) {
            addCriterion("stockEndFlg between", value1, value2, "stockendflg");
            return (Criteria) this;
        }

        public Criteria andStockendflgNotBetween(String value1, String value2) {
            addCriterion("stockEndFlg not between", value1, value2, "stockendflg");
            return (Criteria) this;
        }

        public Criteria andSubsellflgIsNull() {
            addCriterion("subSellFlg is null");
            return (Criteria) this;
        }

        public Criteria andSubsellflgIsNotNull() {
            addCriterion("subSellFlg is not null");
            return (Criteria) this;
        }

        public Criteria andSubsellflgEqualTo(String value) {
            addCriterion("subSellFlg =", value, "subsellflg");
            return (Criteria) this;
        }

        public Criteria andSubsellflgNotEqualTo(String value) {
            addCriterion("subSellFlg <>", value, "subsellflg");
            return (Criteria) this;
        }

        public Criteria andSubsellflgGreaterThan(String value) {
            addCriterion("subSellFlg >", value, "subsellflg");
            return (Criteria) this;
        }

        public Criteria andSubsellflgGreaterThanOrEqualTo(String value) {
            addCriterion("subSellFlg >=", value, "subsellflg");
            return (Criteria) this;
        }

        public Criteria andSubsellflgLessThan(String value) {
            addCriterion("subSellFlg <", value, "subsellflg");
            return (Criteria) this;
        }

        public Criteria andSubsellflgLessThanOrEqualTo(String value) {
            addCriterion("subSellFlg <=", value, "subsellflg");
            return (Criteria) this;
        }

        public Criteria andSubsellflgLike(String value) {
            addCriterion("subSellFlg like", value, "subsellflg");
            return (Criteria) this;
        }

        public Criteria andSubsellflgNotLike(String value) {
            addCriterion("subSellFlg not like", value, "subsellflg");
            return (Criteria) this;
        }

        public Criteria andSubsellflgIn(List<String> values) {
            addCriterion("subSellFlg in", values, "subsellflg");
            return (Criteria) this;
        }

        public Criteria andSubsellflgNotIn(List<String> values) {
            addCriterion("subSellFlg not in", values, "subsellflg");
            return (Criteria) this;
        }

        public Criteria andSubsellflgBetween(String value1, String value2) {
            addCriterion("subSellFlg between", value1, value2, "subsellflg");
            return (Criteria) this;
        }

        public Criteria andSubsellflgNotBetween(String value1, String value2) {
            addCriterion("subSellFlg not between", value1, value2, "subsellflg");
            return (Criteria) this;
        }

        public Criteria andRemarkIsNull() {
            addCriterion("remark is null");
            return (Criteria) this;
        }

        public Criteria andRemarkIsNotNull() {
            addCriterion("remark is not null");
            return (Criteria) this;
        }

        public Criteria andRemarkEqualTo(String value) {
            addCriterion("remark =", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkNotEqualTo(String value) {
            addCriterion("remark <>", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkGreaterThan(String value) {
            addCriterion("remark >", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkGreaterThanOrEqualTo(String value) {
            addCriterion("remark >=", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkLessThan(String value) {
            addCriterion("remark <", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkLessThanOrEqualTo(String value) {
            addCriterion("remark <=", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkLike(String value) {
            addCriterion("remark like", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkNotLike(String value) {
            addCriterion("remark not like", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkIn(List<String> values) {
            addCriterion("remark in", values, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkNotIn(List<String> values) {
            addCriterion("remark not in", values, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkBetween(String value1, String value2) {
            addCriterion("remark between", value1, value2, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkNotBetween(String value1, String value2) {
            addCriterion("remark not between", value1, value2, "remark");
            return (Criteria) this;
        }

        public Criteria andUpdatemanIsNull() {
            addCriterion("updateMan is null");
            return (Criteria) this;
        }

        public Criteria andUpdatemanIsNotNull() {
            addCriterion("updateMan is not null");
            return (Criteria) this;
        }

        public Criteria andUpdatemanEqualTo(String value) {
            addCriterion("updateMan =", value, "updateman");
            return (Criteria) this;
        }

        public Criteria andUpdatemanNotEqualTo(String value) {
            addCriterion("updateMan <>", value, "updateman");
            return (Criteria) this;
        }

        public Criteria andUpdatemanGreaterThan(String value) {
            addCriterion("updateMan >", value, "updateman");
            return (Criteria) this;
        }

        public Criteria andUpdatemanGreaterThanOrEqualTo(String value) {
            addCriterion("updateMan >=", value, "updateman");
            return (Criteria) this;
        }

        public Criteria andUpdatemanLessThan(String value) {
            addCriterion("updateMan <", value, "updateman");
            return (Criteria) this;
        }

        public Criteria andUpdatemanLessThanOrEqualTo(String value) {
            addCriterion("updateMan <=", value, "updateman");
            return (Criteria) this;
        }

        public Criteria andUpdatemanLike(String value) {
            addCriterion("updateMan like", value, "updateman");
            return (Criteria) this;
        }

        public Criteria andUpdatemanNotLike(String value) {
            addCriterion("updateMan not like", value, "updateman");
            return (Criteria) this;
        }

        public Criteria andUpdatemanIn(List<String> values) {
            addCriterion("updateMan in", values, "updateman");
            return (Criteria) this;
        }

        public Criteria andUpdatemanNotIn(List<String> values) {
            addCriterion("updateMan not in", values, "updateman");
            return (Criteria) this;
        }

        public Criteria andUpdatemanBetween(String value1, String value2) {
            addCriterion("updateMan between", value1, value2, "updateman");
            return (Criteria) this;
        }

        public Criteria andUpdatemanNotBetween(String value1, String value2) {
            addCriterion("updateMan not between", value1, value2, "updateman");
            return (Criteria) this;
        }

        public Criteria andUpdatedateIsNull() {
            addCriterion("updateDate is null");
            return (Criteria) this;
        }

        public Criteria andUpdatedateIsNotNull() {
            addCriterion("updateDate is not null");
            return (Criteria) this;
        }

        public Criteria andUpdatedateEqualTo(Date value) {
            addCriterion("updateDate =", value, "updatedate");
            return (Criteria) this;
        }

        public Criteria andUpdatedateNotEqualTo(Date value) {
            addCriterion("updateDate <>", value, "updatedate");
            return (Criteria) this;
        }

        public Criteria andUpdatedateGreaterThan(Date value) {
            addCriterion("updateDate >", value, "updatedate");
            return (Criteria) this;
        }

        public Criteria andUpdatedateGreaterThanOrEqualTo(Date value) {
            addCriterion("updateDate >=", value, "updatedate");
            return (Criteria) this;
        }

        public Criteria andUpdatedateLessThan(Date value) {
            addCriterion("updateDate <", value, "updatedate");
            return (Criteria) this;
        }

        public Criteria andUpdatedateLessThanOrEqualTo(Date value) {
            addCriterion("updateDate <=", value, "updatedate");
            return (Criteria) this;
        }

        public Criteria andUpdatedateIn(List<Date> values) {
            addCriterion("updateDate in", values, "updatedate");
            return (Criteria) this;
        }

        public Criteria andUpdatedateNotIn(List<Date> values) {
            addCriterion("updateDate not in", values, "updatedate");
            return (Criteria) this;
        }

        public Criteria andUpdatedateBetween(Date value1, Date value2) {
            addCriterion("updateDate between", value1, value2, "updatedate");
            return (Criteria) this;
        }

        public Criteria andUpdatedateNotBetween(Date value1, Date value2) {
            addCriterion("updateDate not between", value1, value2, "updatedate");
            return (Criteria) this;
        }

        public Criteria andStatusIsNull() {
            addCriterion("`status` is null");
            return (Criteria) this;
        }

        public Criteria andStatusIsNotNull() {
            addCriterion("`status` is not null");
            return (Criteria) this;
        }

        public Criteria andStatusEqualTo(String value) {
            addCriterion("`status` =", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusNotEqualTo(String value) {
            addCriterion("`status` <>", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusGreaterThan(String value) {
            addCriterion("`status` >", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusGreaterThanOrEqualTo(String value) {
            addCriterion("`status` >=", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusLessThan(String value) {
            addCriterion("`status` <", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusLessThanOrEqualTo(String value) {
            addCriterion("`status` <=", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusLike(String value) {
            addCriterion("`status` like", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusNotLike(String value) {
            addCriterion("`status` not like", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusIn(List<String> values) {
            addCriterion("`status` in", values, "status");
            return (Criteria) this;
        }

        public Criteria andStatusNotIn(List<String> values) {
            addCriterion("`status` not in", values, "status");
            return (Criteria) this;
        }

        public Criteria andStatusBetween(String value1, String value2) {
            addCriterion("`status` between", value1, value2, "status");
            return (Criteria) this;
        }

        public Criteria andStatusNotBetween(String value1, String value2) {
            addCriterion("`status` not between", value1, value2, "status");
            return (Criteria) this;
        }
    }

    /**
     */
    public static class Criteria extends GeneratedCriteria {

        protected Criteria() {
            super();
        }
    }

    public static class Criterion {
        private String condition;

        private Object value;

        private Object secondValue;

        private boolean noValue;

        private boolean singleValue;

        private boolean betweenValue;

        private boolean listValue;

        private String typeHandler;

        public String getCondition() {
            return condition;
        }

        public Object getValue() {
            return value;
        }

        public Object getSecondValue() {
            return secondValue;
        }

        public boolean isNoValue() {
            return noValue;
        }

        public boolean isSingleValue() {
            return singleValue;
        }

        public boolean isBetweenValue() {
            return betweenValue;
        }

        public boolean isListValue() {
            return listValue;
        }

        public String getTypeHandler() {
            return typeHandler;
        }

        protected Criterion(String condition) {
            super();
            this.condition = condition;
            this.typeHandler = null;
            this.noValue = true;
        }

        protected Criterion(String condition, Object value, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.typeHandler = typeHandler;
            if (value instanceof List<?>) {
                this.listValue = true;
            } else {
                this.singleValue = true;
            }
        }

        protected Criterion(String condition, Object value) {
            this(condition, value, null);
        }

        protected Criterion(String condition, Object value, Object secondValue, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.secondValue = secondValue;
            this.typeHandler = typeHandler;
            this.betweenValue = true;
        }

        protected Criterion(String condition, Object value, Object secondValue) {
            this(condition, value, secondValue, null);
        }
    }
}